A relational model for environmental and water resources data
Identifieur interne : 000E67 ( Main/Exploration ); précédent : 000E66; suivant : 000E68A relational model for environmental and water resources data
Auteurs : Jeffery S. Horsburgh [États-Unis] ; David G. Tarboton [États-Unis] ; David R. Maidment [États-Unis] ; Ilya Zaslavsky [États-Unis]Source :
- Water Resources Research [ 0043-1397 ] ; 2008-05.
Abstract
Environmental observations are fundamental to hydrology and water resources, and the way these data are organized and manipulated either enables or inhibits the analyses that can be performed. The Observations Data Model presented here provides a new and consistent format for the storage and retrieval of point environmental observations in a relational database designed to facilitate integrated analysis of large data sets collected by multiple investigators. Within this data model, observations are stored with sufficient ancillary information (metadata) about the observations to allow them to be unambiguously interpreted and to provide traceable heritage from raw measurements to useable information. The design is based upon a relational database model that exposes each single observation as a record, taking advantage of the capability in relational database systems for querying based upon data values and enabling cross‐dimension data retrieval and analysis. This paper presents the design principles and features of the Observations Data Model and illustrates how it can be used to enhance the organization, publication, and analysis of point observations data while retaining a simple relational format. The contribution of the data model to water resources is that it represents a new, systematic way to organize and share data that overcomes many of the syntactic and semantic differences between heterogeneous data sets, thereby facilitating an integrated understanding of water resources based on more extensive and fully specified information.
Url:
DOI: 10.1029/2007WR006392
Affiliations:
Links toward previous steps (curation, corpus...)
- to stream Istex, to step Corpus: 000534
- to stream Istex, to step Curation: 000534
- to stream Istex, to step Checkpoint: 000558
- to stream Main, to step Merge: 000E74
- to stream Main, to step Curation: 000E67
Le document en format XML
<record><TEI wicri:istexFullTextTei="biblStruct"><teiHeader><fileDesc><titleStmt><title xml:lang="en">A relational model for environmental and water resources data</title><author><name sortKey="Horsburgh, Jeffery S" sort="Horsburgh, Jeffery S" uniqKey="Horsburgh J" first="Jeffery S." last="Horsburgh">Jeffery S. Horsburgh</name></author><author><name sortKey="Tarboton, David G" sort="Tarboton, David G" uniqKey="Tarboton D" first="David G." last="Tarboton">David G. Tarboton</name></author><author><name sortKey="Maidment, David R" sort="Maidment, David R" uniqKey="Maidment D" first="David R." last="Maidment">David R. Maidment</name></author><author><name sortKey="Zaslavsky, Ilya" sort="Zaslavsky, Ilya" uniqKey="Zaslavsky I" first="Ilya" last="Zaslavsky">Ilya Zaslavsky</name></author></titleStmt><publicationStmt><idno type="wicri:source">ISTEX</idno><idno type="RBID">ISTEX:AFB9E15FD6874BC774E09A8AF7D19309ABB44058</idno><date when="2008" year="2008">2008</date><idno type="doi">10.1029/2007WR006392</idno><idno type="url">https://api.istex.fr/document/AFB9E15FD6874BC774E09A8AF7D19309ABB44058/fulltext/pdf</idno><idno type="wicri:Area/Istex/Corpus">000534</idno><idno type="wicri:Area/Istex/Curation">000534</idno><idno type="wicri:Area/Istex/Checkpoint">000558</idno><idno type="wicri:doubleKey">0043-1397:2008:Horsburgh J:a:relational:model</idno><idno type="wicri:Area/Main/Merge">000E74</idno><idno type="wicri:Area/Main/Curation">000E67</idno><idno type="wicri:Area/Main/Exploration">000E67</idno></publicationStmt><sourceDesc><biblStruct><analytic><title level="a" type="main" xml:lang="en">A relational model for environmental and water resources data</title><author><name sortKey="Horsburgh, Jeffery S" sort="Horsburgh, Jeffery S" uniqKey="Horsburgh J" first="Jeffery S." last="Horsburgh">Jeffery S. Horsburgh</name><affiliation wicri:level="1"><country xml:lang="fr">États-Unis</country><wicri:regionArea>Utah Water Research Laboratory, Utah State University, Utah, Logan</wicri:regionArea><wicri:noRegion>Logan</wicri:noRegion></affiliation><affiliation wicri:level="1"><country wicri:rule="url">États-Unis</country></affiliation></author><author><name sortKey="Tarboton, David G" sort="Tarboton, David G" uniqKey="Tarboton D" first="David G." last="Tarboton">David G. Tarboton</name><affiliation wicri:level="1"><country xml:lang="fr">États-Unis</country><wicri:regionArea>Utah Water Research Laboratory, Utah State University, Utah, Logan</wicri:regionArea><wicri:noRegion>Logan</wicri:noRegion></affiliation></author><author><name sortKey="Maidment, David R" sort="Maidment, David R" uniqKey="Maidment D" first="David R." last="Maidment">David R. Maidment</name><affiliation wicri:level="4"><country xml:lang="fr">États-Unis</country><wicri:regionArea>Center for Research in Water Resources, University of Texas at Austin, Texas, Austin</wicri:regionArea><orgName type="university">Université du Texas à Austin</orgName><placeName><settlement type="city">Austin (Texas)</settlement><region type="state">Texas</region></placeName></affiliation></author><author><name sortKey="Zaslavsky, Ilya" sort="Zaslavsky, Ilya" uniqKey="Zaslavsky I" first="Ilya" last="Zaslavsky">Ilya Zaslavsky</name><affiliation wicri:level="1"><country xml:lang="fr">États-Unis</country><wicri:regionArea>San Diego Supercomputer Center, University of California, San Diego, California, La Jolla</wicri:regionArea><wicri:noRegion>La Jolla</wicri:noRegion></affiliation></author></analytic><monogr></monogr><series><title level="j">Water Resources Research</title><title level="j" type="abbrev">Water Resour. Res.</title><idno type="ISSN">0043-1397</idno><idno type="eISSN">1944-7973</idno><imprint><publisher>Blackwell Publishing Ltd</publisher><date type="published" when="2008-05">2008-05</date><biblScope unit="volume">44</biblScope><biblScope unit="issue">5</biblScope><biblScope unit="page" from="/">n/a</biblScope><biblScope unit="page" to="/">n/a</biblScope></imprint><idno type="ISSN">0043-1397</idno></series><idno type="istex">AFB9E15FD6874BC774E09A8AF7D19309ABB44058</idno><idno type="DOI">10.1029/2007WR006392</idno><idno type="ArticleID">2007WR006392</idno></biblStruct></sourceDesc><seriesStmt><idno type="ISSN">0043-1397</idno></seriesStmt></fileDesc><profileDesc><textClass></textClass><langUsage><language ident="en">en</language></langUsage></profileDesc></teiHeader><front><div type="abstract">Environmental observations are fundamental to hydrology and water resources, and the way these data are organized and manipulated either enables or inhibits the analyses that can be performed. The Observations Data Model presented here provides a new and consistent format for the storage and retrieval of point environmental observations in a relational database designed to facilitate integrated analysis of large data sets collected by multiple investigators. Within this data model, observations are stored with sufficient ancillary information (metadata) about the observations to allow them to be unambiguously interpreted and to provide traceable heritage from raw measurements to useable information. The design is based upon a relational database model that exposes each single observation as a record, taking advantage of the capability in relational database systems for querying based upon data values and enabling cross‐dimension data retrieval and analysis. This paper presents the design principles and features of the Observations Data Model and illustrates how it can be used to enhance the organization, publication, and analysis of point observations data while retaining a simple relational format. The contribution of the data model to water resources is that it represents a new, systematic way to organize and share data that overcomes many of the syntactic and semantic differences between heterogeneous data sets, thereby facilitating an integrated understanding of water resources based on more extensive and fully specified information.</div></front></TEI><affiliations><list><country><li>États-Unis</li></country><region><li>Texas</li></region><settlement><li>Austin (Texas)</li></settlement><orgName><li>Université du Texas à Austin</li></orgName></list><tree><country name="États-Unis"><noRegion><name sortKey="Horsburgh, Jeffery S" sort="Horsburgh, Jeffery S" uniqKey="Horsburgh J" first="Jeffery S." last="Horsburgh">Jeffery S. Horsburgh</name></noRegion><name sortKey="Horsburgh, Jeffery S" sort="Horsburgh, Jeffery S" uniqKey="Horsburgh J" first="Jeffery S." last="Horsburgh">Jeffery S. Horsburgh</name><name sortKey="Maidment, David R" sort="Maidment, David R" uniqKey="Maidment D" first="David R." last="Maidment">David R. Maidment</name><name sortKey="Tarboton, David G" sort="Tarboton, David G" uniqKey="Tarboton D" first="David G." last="Tarboton">David G. Tarboton</name><name sortKey="Zaslavsky, Ilya" sort="Zaslavsky, Ilya" uniqKey="Zaslavsky I" first="Ilya" last="Zaslavsky">Ilya Zaslavsky</name></country></tree></affiliations></record>Pour manipuler ce document sous Unix (Dilib)
EXPLOR_STEP=$WICRI_ROOT/Ticri/CIDE/explor/CyberinfraV1/Data/Main/Exploration
HfdSelect -h $EXPLOR_STEP/biblio.hfd -nk 000E67 | SxmlIndent | more
Ou
HfdSelect -h $EXPLOR_AREA/Data/Main/Exploration/biblio.hfd -nk 000E67 | SxmlIndent | more
Pour mettre un lien sur cette page dans le réseau Wicri
{{Explor lien
|wiki= Ticri/CIDE
|area= CyberinfraV1
|flux= Main
|étape= Exploration
|type= RBID
|clé= ISTEX:AFB9E15FD6874BC774E09A8AF7D19309ABB44058
|texte= A relational model for environmental and water resources data
}}
| This area was generated with Dilib version V0.6.25. |  |